/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package py.una.pol.ii.is2.controller.reportes;

import com.sun.rave.web.ui.appbase.AbstractPageBean;
import com.sun.webui.jsf.component.Button;
import com.sun.webui.jsf.component.RadioButtonGroup;
import com.sun.webui.jsf.component.TextField;
import com.sun.webui.jsf.model.Option;
import java.io.File;
import java.sql.Connection;
import java.util.HashMap;
import java.util.Map;
import javax.faces.FacesException;
import javax.faces.context.FacesContext;
import javax.servlet.ServletContext;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;
import net.sf.jasperreports.engine.JRExporterParameter;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.JasperRunManager;
import net.sf.jasperreports.engine.design.JasperDesign;
import net.sf.jasperreports.engine.export.JRCsvExporter;
import net.sf.jasperreports.engine.export.JRCsvExporterParameter;
import net.sf.jasperreports.engine.export.JRXlsExporter;
import net.sf.jasperreports.engine.export.JRXlsExporterParameter;
import net.sf.jasperreports.engine.util.JRLoader;
import net.sf.jasperreports.engine.xml.JRXmlLoader;
import py.una.pol.ii.is2.controller.SessionBean1;
import py.una.pol.ii.is2.controller.ControlAcceso;
import py.una.pol.ii.is2.controller.ApplicationBean1;
import py.una.pol.ii.is2.controller.RequestBean1;
import py.una.pol.ii.is2.jdbc.ConnectPg;

/**
 * <p>Page bean that corresponds to a similarly named JSP page.  This
 * class contains component definitions (and initialization code) for
 * all components that you have defined on this page, as well as
 * lifecycle methods and event handlers where you may add behavior
 * to respond to incoming events.</p>
 *
 * @version rpt_usuarios.java
 * @version Created on 15-jul-2009, 7:44:53
 * @author liz
 */
public class ReporteUsuarios extends AbstractPageBean {

    private void _init() throws Exception {
    }
    private TextField txtNombreRol = new TextField();

    public TextField getTxtNombreRol() {
        return txtNombreRol;
    }

    public void setTxtNombreRol(TextField tf) {
        this.txtNombreRol = tf;
    }
    private RadioButtonGroup btnReporte1 = new RadioButtonGroup();

    public RadioButtonGroup getBtngrpReporte1() {
        return btnReporte1;
    }

    public void setBtngrpReporte1(RadioButtonGroup rbg) {
        this.btnReporte1 = rbg;
    }
    private Option opciones[] = new Option[3];

    public Option[] getOpciones() {
        return opciones;
    }

    public void setOpciones(Option[] opciones) {
        this.opciones = opciones;
    }

    private void cargaOpciones() {
        opciones[0] = new Option();
        opciones[0].setValue("pdf");
        opciones[0].setLabel("PDF");
        opciones[1] = new Option();
        opciones[1].setValue("xls");
        opciones[1].setLabel("XLS");
        opciones[2] = new Option();
        opciones[2].setValue("cvs");
        opciones[2].setLabel("CSV");
    }
    private Button btnReporte = new Button();

    public Button getBtnReporte() {
        return btnReporte;
    }

    public void setBtnReporte(Button b) {
        this.btnReporte = b;
    }
    private RadioButtonGroup radioFormato = new RadioButtonGroup();

    public RadioButtonGroup getRadioFormato() {
        return radioFormato;
    }

    public void setRadioFormato(RadioButtonGroup rbg) {
        this.radioFormato = rbg;
    }

    /**
     * <p>Construct a new Page bean instance.</p>
     */
    public ReporteUsuarios() {
    }

    /**
     * <p>Callback method that is called whenever a page is navigated to,
     * either directly via a URL, or indirectly via page navigation.
     * Customize this method to acquire resources that will be needed
     * for event handlers and lifecycle methods, whether or not this
     * page is performing post back processing.</p>
     * 
     * <p>Note that, if the current request is a postback, the property
     * values of the components do <strong>not</strong> represent any
     * values submitted with this request.  Instead, they represent the
     * property values that were saved for this view when it was rendered.</p>
     */
    @Override
    public void init() {
        // Perform initializations inherited from our superclass
        super.init();
        // Perform application initialization that must complete
        // *before* managed components are initialized
        // TODO - add your own initialiation code here

        // <editor-fold defaultstate="collapsed" desc="Managed Component Initialization">
        // Initialize automatically managed components
        // *Note* - this logic should NOT be modified
        try {
            _init();
        } catch (Exception e) {
            log("rpt_usuarios Initialization Failure", e);
            throw e instanceof FacesException ? (FacesException) e : new FacesException(e);
        }

    // </editor-fold>
    // Perform application initialization that must complete
    // *after* managed components are initialized
    // TODO - add your own initialization code here
    }

    public void settxtCodUsuario(TextField tf) {
    }

    /**
     * <p>Callback method that is called after the component tree has been
     * restored, but before any event processing takes place.  This method
     * will <strong>only</strong> be called on a postback request that
     * is processing a form submit.  Customize this method to allocate
     * resources that will be required in your event handlers.</p>
     */
    @Override
    public void preprocess() {
    }

    /**
     * <p>Callback method that is called just before rendering takes place.
     * This method will <strong>only</strong> be called for the page that
     * will actually be rendered (and not, for example, on a page that
     * handled a postback and then navigated to a different page).  Customize
     * this method to allocate resources that will be required for rendering
     * this page.</p>
     */
    @Override
    public void prerender() {
        cargaOpciones();
    }

    /**
     * <p>Callback method that is called after rendering is completed for
     * this request, if <code>init()</code> was called (regardless of whether
     * or not this was the page that was actually rendered).  Customize this
     * method to release resources acquired in the <code>init()</code>,
     * <code>preprocess()</code>, or <code>prerender()</code> methods (or
     * acquired during execution of an event handler).</p>
     */
    @Override
    public void destroy() {
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected SessionBean1 getSessionBean1() {
        return (SessionBean1) getBean("SessionBean1");
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected ControlAcceso getControlAcceso() {
        return (ControlAcceso) getBean("ControlAcceso");
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected ApplicationBean1 getApplicationBean1() {
        return (ApplicationBean1) getBean("ApplicationBean1");
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected RequestBean1 getRequestBean1() {
        return (RequestBean1) getBean("RequestBean1");
    }

    public String btnReporte_action() {
        String[] sparamName = new String[1];
        String[] sparamValue = new String[2];

        /* CONEXIÓN A LA DB */
        ConnectPg connPg = new ConnectPg();
        Connection conn = connPg.getConnection();
        ServletContext theApplicationsServletContext = (ServletContext) this.getExternalContext().getContext();


        String nombre_rol = "";
        String sSql = "";
        String sPath = "";

        try {

            if (txtNombreRol.toString() != null && !txtNombreRol.toString().equals("")) {
                nombre_rol = txtNombreRol.toString().toString();
            }


            sSql = nombre_rol;

            sPath = theApplicationsServletContext.getRealPath("/resources/images/");
//            sparamName[0] = "parametros";
            sparamName[0] = "imgurl";
//            sparamValue[0] = sSql;
            sparamValue[0] = sPath;

            if (radioFormato.getSelected().toString().compareToIgnoreCase("pdf") == 0) {
                System.out.print("entre pdf");
                getReport(conn, "caracteristicas.jasper", sparamName, sparamValue, theApplicationsServletContext);
            }

            if (radioFormato.getSelected().toString().compareToIgnoreCase("xls") == 0) {
                getReportExcel(conn, "xls_reportUsuarios.jrxml", sparamName, sparamValue, theApplicationsServletContext);
                System.out.print("entre xls");
            }

            if (radioFormato.getSelected().toString().compareToIgnoreCase("cvs") == 0) {
                getReportCvs(conn, "cvs_reportUsuarios.jrxml", sparamName, sparamValue, theApplicationsServletContext);
                System.out.print("entre cvs");
            }
        } catch (Exception e) {
            error("Error al generar el reporte ");
            error(" " + e);
        } finally {
            connPg.cerrarConnection(conn);
        }

        return null;
    }

    public void getReport(Connection conn, String sNameReport, String[] sParametersNames, String[] sParametersValues, ServletContext sc)
            throws Exception {
        String realPathXml = sc.getRealPath("reportes/");
        try {
            //JRPdfExporter exporter = new JRPdfExporter();
            // FontKey fontk= new FontKey("COMIC", false, false);
            // PdfFont pdffont= new PdfFont("C:/WINDOWS/FONTS/COMIC.TTF", BaseFont.CP1250, true);
            // Map fontmap= new HashMap();
            // fontmap.put(fontk, pdffont);
            // exporter.setParameter(JRPdfExporterParameter.FONT_MAP, fontmap);
            // First, load JasperDesign from XML and compile it into JasperReport
//            System.out.println("Camino al xml : " + realPathXml+ "/" + sNameReport);
//            File archivo = new File(realPathXml+ "/" + sNameReport);
//            InputStream is = new FileInputStream(archivo);
//            LegacyJasperInputStream legacy = new LegacyJasperInputStream(is);
            
//            JasperDesign jasperDesign = JRXmlLoader.load(is);
//            JasperDesign jasperDesign = (JasperReport)JRLoader.loadObject("reporte1.jasper");
//            JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);
            System.out.println("path : " + realPathXml+ "/" + sNameReport);

            String path = realPathXml + "/resources/images/";

            JasperReport jasperReport = (JasperReport)JRLoader.loadObject(sNameReport);
            
            // Second, create a map of parameters to pass to the report.
            Map parameters = new HashMap();
            parameters.put("imagen", path);

//            for (int i = 0; i < sParametersNames.length; i++) {
//                parameters.put(sParametersNames[i], sParametersValues[i]);
//            }
            // Third, get a database connection

            // Fourth, create JasperPrint using fillReport() method
            byte[] pdf = null;

            pdf = JasperRunManager.runReportToPdf(jasperReport, parameters, conn);
            JasperPrint jp = JasperFillManager.fillReport(jasperReport, null, conn);
            // You can use JasperPrint to create PDF
            FacesContext faces = FacesContext.getCurrentInstance();
            HttpServletResponse response =
                    (HttpServletResponse) faces.getExternalContext().getResponse();
            response.setContentType("application/pdf");
            response.setContentLength(pdf.length);
            response.setHeader("Content-disposition", "inline; filename=\"MyPdf.pdf\"");


            //exporter.setParameter(JRExporterParameter.JASPER_PRINT,  jp);
            //exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, response.getOutputStream());

            //exporter.exportReport();

            ServletOutputStream out = response.getOutputStream();
            out.write(pdf);

            faces.responseComplete();
        } catch (Exception e) {
            e.printStackTrace();
            throw e;
        }
    }

    public void getReportExcel(Connection conn, String sNameReport, String[] sParametersNames, String[] sParametersValues, ServletContext sc) throws Exception {
        String realPathXml = sc.getRealPath("/WEB-INF/classes/py/una/pol/ii/is2/reportes/");
        try {
            JasperDesign jasperDesign = JRXmlLoader.load(realPathXml + "/" + sNameReport);
            JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);

            Map parameters = new HashMap();

            for (int i = 0; i < sParametersNames.length; i++) {
                parameters.put(sParametersNames[i], sParametersValues[i]);
            }

            JasperPrint jp = JasperFillManager.fillReport(jasperReport, parameters, conn);
            FacesContext faces = FacesContext.getCurrentInstance();
            File destFile = new File(realPathXml, jp.getName() + ".xls");
            JRXlsExporter xlsExporter = new JRXlsExporter();
            HttpServletResponse response = (HttpServletResponse) faces.getExternalContext().getResponse();

            xlsExporter.setParameter(JRExporterParameter.JASPER_PRINT, jp);
            xlsExporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destFile.toString());
            xlsExporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);

            xlsExporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);
            xlsExporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
            xlsExporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
            xlsExporter.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, response.getOutputStream());

            response.setHeader("Content-Disposition", "inline;filename=" + destFile);
            response.setContentType("application/vnd.ms-excel");
            xlsExporter.exportReport();

        } catch (Exception e) {
            // e.printStackTrace();
            throw e;
        }

    }

    public void getReportCvs(Connection conn, String sNameReport, String[] sParametersNames, String[] sParametersValues, ServletContext sc) throws Exception {
        String realPathXml = sc.getRealPath("/WEB-INF/classes/py/una/pol/ii/is2/reportes/");
        try {
            JasperDesign jasperDesign = JRXmlLoader.load(realPathXml + "/" + sNameReport);
            JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);

            Map parameters = new HashMap();

            for (int i = 0; i < sParametersNames.length; i++) {
                parameters.put(sParametersNames[i], sParametersValues[i]);
            }

            JasperPrint jp = JasperFillManager.fillReport(jasperReport, parameters, conn);
            FacesContext faces = FacesContext.getCurrentInstance();
            File destFile = new File(realPathXml, jp.getName() + ".csv");
            JRCsvExporter csvExporter = new JRCsvExporter();
            HttpServletResponse response = (HttpServletResponse) faces.getExternalContext().getResponse();

            csvExporter.setParameter(JRCsvExporterParameter.JASPER_PRINT, jp);
            csvExporter.setParameter(JRCsvExporterParameter.OUTPUT_FILE_NAME, destFile.toString());
            //csvExporter.setParameter(JRCsvExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);

            // csvExporter.setParameter(JRCsvExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);
            //  csvExporter.setParameter(JRCsvExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
            //  csvExporter.setParameter(JRCsvExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
            csvExporter.setParameter(JRCsvExporterParameter.OUTPUT_STREAM, response.getOutputStream());

            response.setHeader("Content-Disposition", "inline;filename=" + destFile);
            response.setContentType("application/vnd.ms-excel");
            csvExporter.exportReport();

        } catch (Exception e) {
            e.printStackTrace();
            throw e;
        }

    }
}